ODBC

Declaration:

FUNCTION DBDocAddConn

( dsn :DYNARRAY[] of CHAR;

userName :DYNARRAY[] of CHAR;

password :DYNARRAY[] of CHAR

) :BOOLEAN ;

Description:

Add a database connection to the current document

DBDocGetColumns

ODBC

Declaration:

FUNCTION DBDocGetColumns

( database :STRING;

table :STRING;

VAR outNames :DYNARRAY[] of CHAR;

VAR outTypes :DYNARRAY[] of CHAR;

VAR outCanBeKey :DYNARRAY[] of CHAR;

VAR outIsKey :DYNARRAY[] of CHAR

) :BOOLEAN ;

Description:

Returns a string representing a ';' delimited lists of the specified table data.

DBDocGetConn

ODBC

Declaration:

FUNCTION DBDocGetConn

( databaseName :DYNARRAY[] of CHAR;

VAR outUserName :DYNARRAY[] of CHAR;

VAR outPassword :DYNARRAY[] of CHAR

) :BOOLEAN ;

Description:

Get database connection info.

DBDocGetDB

ODBC

Declaration:

FUNCTION DBDocGetDB

( VAR outDatabases:DYNARRAY[] of CHAR ) :BOOLEAN ;

Description:

Returns a string representing a ';' delimited list of the databases currectly connected to the document.

DBDocGetTables

ODBC

Declaration:

FUNCTION DBDocGetTables

( database :STRING;

VAR outTables :DYNARRAY[] of CHAR

) :BOOLEAN ;

Description:

Returns a string representing a ';' delimited list of the tables in the specified database.

DBDocHasConn

ODBC

Declaration:

FUNCTION DBDocHasConn

:BOOLEAN ;

Description:

Checks if the current document has connections to an ODBC data source.

DBDocRemoveConn

ODBC

Declaration:

FUNCTION DBDocRemoveConn

( databaseName:DYNARRAY[] of CHAR ) :BOOLEAN ;

Description:

Remove a database connection from the current document

DBDocSetColKey

ODBC

Declaration:

FUNCTION DBDocSetColKey

( databaseName :DYNARRAY[] of CHAR;

tableName :DYNARRAY[] of CHAR;

columnName :DYNARRAY[] of CHAR;

setIsKey :BOOLEAN

) :BOOLEAN ;

Description:

Get database table column to be as a key.

DBGetFormatConn

ODBC

Declaration:

FUNCTION DBGetFormatConn

( formatName :STRING;

VAR outDatabase :STRING;

VAR outTable :STRING

) :BOOLEAN ;

Description:

Returns the ODBC connection for the specified format.

DBGetFormatFieldConn

ODBC

Declaration:

FUNCTION DBGetFormatFieldConn

( formatName :STRING;

VAR fieldName :STRING;

VAR columnName :STRING;

VAR linkType :INTEGER

) :BOOLEAN ;

Description:

Get ODBC connection for the specified format field.

DBObjSQLGetRead

ODBC

Declaration:

FUNCTION DBObjSQLGetRead

( hObject :HANDLE;

VAR SQLSentence :DYNARRAY[] of CHAR

) :BOOLEAN ;

Description:

Get an object's SQL sentence for ODBC read.

DBObjSQLGetWrite

ODBC

Declaration:

FUNCTION DBObjSQLGetWrite

( hObject :HANDLE;

VAR SQLSentence :DYNARRAY[] of CHAR

) :BOOLEAN ;

Description:

Get an object's SQL sentence for ODBC write.

DBObjSQLSetRead

ODBC

Declaration:

FUNCTION DBObjSQLSetRead

( hObject :HANDLE;

SQLSentence :DYNARRAY[] of CHAR

) :BOOLEAN ;

Description:

Set an object's SQL sentence for ODBC read.

DBObjSQLSetWrite

ODBC

Declaration:

FUNCTION DBObjSQLSetWrite

( hObject :HANDLE;

SQLSentence :DYNARRAY[] of CHAR

) :BOOLEAN ;

Description:

Set an object's SQL sentence for ODBC write.

DBSetFormatConn

ODBC

Declaration:

FUNCTION DBSetFormatConn

( formatName :STRING;

database :STRING;

tableName :STRING

) :BOOLEAN ;

Description:

Set ODBC connection for the specified format.

DBSetFormatFieldConn

ODBC

Declaration:

FUNCTION DBSetFormatFieldConn

( formatName :STRING;

fieldName :STRING;

columnName :STRING;

linkType :INTEGER

) :BOOLEAN ;

Description:

Set ODBC connection for the specified format field.

DBShowDBTableDlg

ODBC

Declaration:

FUNCTION DBShowDBTableDlg

( database :STRING;

table :STRING

) :BOOLEAN ;

Description:

Show the specified database table dialog.

DBShowManageDBsDlg

ODBC

Declaration:

PROCEDURE DBShowManageDBsDlg

;

Description:

Show the database manager dialog.

DBShowObjConnDlg

ODBC

Declaration:

FUNCTION DBShowObjConnDlg

:BOOLEAN ;

Description:

Show the object connection dialog for the selected objects.

DBSQLExecute

ODBC

Declaration:

FUNCTION DBSQLExecute

( database :STRING;

SQLQuery :DYNARRAY[] of CHAR;

VAR outColumnCnt :LONGINT;

VAR outResultSetInst :LONGINT

) :BOOLEAN ;

Description:

Executes a SQL in the specified database connected to the current document. Note! The resultSetInstance have to be deleted with call to 'DBSQLExecuteDelete'

DBSQLExecuteDelete

ODBC

Declaration:

PROCEDURE DBSQLExecuteDelete

( VAR resultSetInst:LONGINT ) ;

Description:

Deletes a resultSetInstance created with 'DBSQLExecute' or 'DBSQLExecuteDSN'

DBSQLExecuteDSN

ODBC

Declaration:

FUNCTION DBSQLExecuteDSN

( dsn :DYNARRAY[] of CHAR;

userName :DYNARRAY[] of CHAR;

password :DYNARRAY[] of CHAR;

SQLQuery :DYNARRAY[] of CHAR;

VAR outColumnCnt :LONGINT;

VAR outResultSetInst :LONGINT

) :BOOLEAN ;

Description:

Executes a SQL in the specified DSN registered in the ODBC manager. Note! The resultSetInstance have to be deleted with call to 'DBSQLExecuteDelete'

DBSQLExecuteError

ODBC

Declaration:

FUNCTION DBSQLExecuteError

( VAR message :DYNARRAY[] of CHAR;

VAR state :DYNARRAY[] of CHAR;

VAR code :LONGINT;

VAR internalDesc :DYNARRAY[] of CHAR

) :BOOLEAN ;

Description:

Return information about the last error occured in the ODBC API functions.

DBSQLExecuteGet

ODBC

Declaration:

FUNCTION DBSQLExecuteGet

( resultSetInst :LONGINT;

colIndex :LONGINT;

VAR outColumnName :DYNARRAY[] of CHAR;

VAR outValue :DYNARRAY[] of CHAR

) :BOOLEAN ;

Description:

Retrieves information from the resultSetInstance created with 'DBSQLExecute' or 'DBSQLExecuteDSN'

DBSQLExecuteNext

ODBC

Declaration:

FUNCTION DBSQLExecuteNext

( resultSetInst:LONGINT ) :BOOLEAN ;

Description:

Moves the resultSet current pointer to the next entry.